MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Role = 70

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Culture, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
15124 67.654.3 0 0 16390 American Decorative Arts 1 Drawing 23 Design for Buffalo Theater, Buffalo, New York American 1         Artist|Artist|Maker 70   B. Stanton|Louis Comfort Tiffany|Tiffany Studios American, New York 1848–1933 New York|1902–32   Stanton, B.|Tiffany, Louis Comfort|Tiffany Studios  2359 American 1 1848 |1902 1933 |1932 ca. 1925–26 1922 1926 Watercolor, gouache, black ink, and graphite on off-white wove paper 2554 26 11/16 x 39 9/16 in. (67.8 x 100.5 cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
15145 67.654.398 0 1 16411 American Decorative Arts 1 Drawing 23 Design for beatitude window in presentation portfolio for Arlington Street Church, Boston, Massachusetts American 1         Artist|Artist|Maker 70   Louis Comfort Tiffany|Frederick Wilson|Tiffany Studios American, New York 1848–1933 New York|American (born Ireland) Dublin 1858-1932 Los Angeles, California|1902–32 1858-1932 Tiffany, Louis Comfort|Wilson, Frederick|Tiffany Studios  2362   1848 |1858 |1902 1933 |1932 |1932 ca. 1905 1905 1905 Watercolor, gouache, brown ink, and graphite on artists board with mat, set in presentation portfolio of wood pulp paper. 2574 Overall (closed): 10 1/2 x 5 1/2 in. (26.7 x 14 cm) Overall (open): 13 5/8 x 17 1/2 in. (34.6 x 44.5 cm) Purchase, Walter Hoving and Julia T. Weld Gifts and Dodge Fund, 1967 Made in 1       United States 3             Drawings 9   Metropolitan Museum of Art, New York, NY 1
105773 17.190.639 0 1 193609 European Sculpture and Decorative Arts 3 Mirror clock 7598 Mirror clock German, Nuremberg 147         Artist|Artist|Maker 70 Band of case from design by|Stem and foot probably cast from designs by|Movement attributed to Cornelis Bos|Matthias Zündt|Master CR Netherlandish, Hertogenbosch ca. 1510?–before 1566 Groningen|German, probably ca. 1498–1572 Nürnberg|probably active before 1565   Bos, Cornelis|Zündt, Matthias|CR Master 9079   1510 |1498 1566 |1572 |1565 ca. 1565–70 1560 1575 Case: gilded brass and gilded copper; Dial: gilded brass; Movement: plated frame of iron, iron wheels 21322 Overall: 16 × 6 1/4 × 1 1/4 in. (40.6 × 15.9 × 3.2 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
105997 17.190.1152 0 1 193834 European Sculpture and Decorative Arts 3 Snuffbox, painting 7005 Snuffbox with six scenes of country pastimes French, Paris 114         Artist|Artist|Maker 70 Miniatures by|and|Box by Louis Nicolas van Blarenberghe|Henri Joseph van Blarenberghe|Pierre François Drais French, Lille 1716–1794 Fontainebleau|French, Lille 1750–1826 Lille|French, 1726–ca. 1788   Blarenberghe, Louis Nicolas van|Blarenberghe, Henri Joseph van|Drais, Pierre François 9124 French|French|French 103 1716 |1750 |1726 1794 |1826 |1793 1774–75 1774 1775 Gold, glass; miniatures: gouache on vellum 21422 Overall (confirmed): 1 3/8 x 3 3/8 x 2 1/2 in. (3.5 x 8.5 x 6.4 cm); Miniaitures: Top, oval, 2 1/8 x 3 in. (53 x 74 mm); bottom, oval, 2 1/8 x 3 in. (53 x 74 mm); front 3/4 x 1 7/8 in. (21 x 48 mm); back 3/4 x 1 7/8 in. (21 x 48 mm); left side 3/4 x 1 7/8 in. (21 x 48 mm); right side 3/4 x 1 7/8 in. (21 x 48 mm) Gift of J. Pierpont Morgan, 1917                       Metalwork-Gold and Platinum|Miniatures 317   Metropolitan Museum of Art, New York, NY 1
106377 17.190.1627 0 1 194215 European Sculpture and Decorative Arts 3 Watch 557 Watch French, Paris or Blois 2680         Artist|Artist|Maker 70 After a painting by|Enamel scene of St. John the Baptist based on an engraving by|Watchmaker: Jacques Stella|Gilles Rousselet|Jacques Goullons French, Lyons 1596–1657 Paris|French, Paris 1614–1686 Paris|French, active Paris, 1626–died 1671   Stella, Jacques|Rousselet, Gilles|Goullons, Jacques 9338 French 2 1596 |1614 |1626 1657 |1686 |1671 ca. 1645–50 1640 1655 Case and dial: painted enamel on gold; Movement: gilded brass and steel, partly blued 21627 Overall: 2 5/8 × 2 5/16 in. (6.7 × 5.9 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
106689 18.129.1 0 1 194540 European Sculpture and Decorative Arts 3 Dish 110 Dish probably Italian, Pesaro 2725         Artist|Artist|Maker 70 After a print by|After a painting by|Probably Marcantonio Raimondi|Raphael (Raffaello Sanzio or Santi)|Ferruccio Mengaroni Italian, Argini (?) ca. 1480–before 1534 Bologna (?)|Italian, Urbino 1483–1520 Rome|Italian, 1876–1925   Raimondi, Marcantonio|Raphael (Raffaello Sanzio or Santi)|Mengaroni, Ferruccio 9391 Italian|Italian 93 1475 |1483 |1876 1534 |1520 |1925 late 19th or early 20th century 1885 1915 Maiolica (tin-glazed earthenware) 20530 Overall (confirmed): 2 x 17 3/8 in. (5.1 x 44.1 cm) Gift of J. Pierpont Morgan, 1918                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 122.975ms · Data license: CC0 · Data source: metmuseum/openaccess